﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="housekeepingReport.aspx.cs" Inherits="SWENAssignment.housekeepingReport" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
    <style type="text/css">
        .auto-style3 {
            height: 23px;
        }
        .auto-style4 {
            height: 22px;
        }
        .auto-style5 {
            height: 23px;
            background-color: #CCFFCC;
        }
        .auto-style6 {
            width: 950px;
            height: 280px;
        }
    </style>
</head>
<body style="background-color: #CCFFCC">
    <form id="form1" runat="server">
    <div>
    
        <table class="auto-style1">
            <tr>
                <td colspan="2">
                    <img alt="banner" class="auto-style6" src="../Images/jjw-dona-filipa-hotel-home-banner-01.jpg" /></td>
            </tr>
            <tr>
                <td colspan="2"><strong>WELCOME TO DELONIX REGIA HOTEL MANAGEMENT SYSTEM</strong></td>
            </tr>
            <tr>
                <td class="auto-style3" colspan="2"></td>
            </tr>
            <tr>
                <td class="auto-style3" colspan="2">
                    <asp:Menu ID="Menu1" runat="server" StaticSubMenuIndent="16px" style="font-size: large; font-weight: 700">
                        <Items>
                            <asp:MenuItem NavigateUrl="~/Homepage.aspx" Text="Homepage" Value="Homepage"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/listOfAllRooms.aspx" Text="List of All Rooms" Value="List of All Rooms"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/listAllDetailsByRoomNumber.aspx" Text="List of Guests Details by Room Number" Value="List of Guests Details by Room Number"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/listAllGuestNameByDate.aspx" Text="List of All Guest Name in All Rooms By Date Range" Value="List of All Guest Name in All Rooms By Date Range"></asp:MenuItem>
                            <asp:MenuItem NavigateUrl="~/Dennis/reportingLogin.aspx" Text="Room Occupancy &amp; Housekeeping Report" Value="Room Occupancy &amp; Housekeeping Report"></asp:MenuItem>
                        </Items>
                    </asp:Menu>
                </td>
            </tr>
            <tr>
                <td colspan="2" class="auto-style3"></td>
            </tr>
            <tr>
                <td class="auto-style4" colspan="2">Housekeeping Report</td>
            </tr>
            <tr>
                <td colspan="2" class="auto-style3"></td>
            </tr>
            <tr>
                <td class="auto-style3">Date:</td>
                <td class="auto-style3">
                    <asp:Label ID="lblDate" runat="server"></asp:Label>
                </td>
            </tr>
            <tr>
                <td class="auto-style3">&nbsp;</td>
                <td class="auto-style3">&nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style3">&nbsp;</td>
                <td class="auto-style3">
                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="roomNum" DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" GridLines="None">
                        <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                        <Columns>
                            <asp:BoundField DataField="floor" HeaderText="floor" SortExpression="floor" />
                            <asp:BoundField DataField="attendant" HeaderText="attendant" SortExpression="attendant" />
                            <asp:BoundField DataField="roomNum" HeaderText="roomNum" ReadOnly="True" SortExpression="roomNum" />
                            <asp:BoundField DataField="timeStart" HeaderText="timeStart" SortExpression="timeStart" />
                            <asp:BoundField DataField="timeEnd" HeaderText="timeEnd" SortExpression="timeEnd" />
                            <asp:BoundField DataField="vacantYesOrNo" HeaderText="vacantYesOrNo" SortExpression="vacantYesOrNo" />
                            <asp:BoundField DataField="numBedSheets" HeaderText="numBedSheets" SortExpression="numBedSheets" />
                            <asp:BoundField DataField="numPillowCases" HeaderText="numPillowCases" SortExpression="numPillowCases" />
                            <asp:BoundField DataField="numHandTowels" HeaderText="numHandTowels" SortExpression="numHandTowels" />
                            <asp:BoundField DataField="numBathMats" HeaderText="numBathMats" SortExpression="numBathMats" />
                            <asp:BoundField DataField="numBathRugs" HeaderText="numBathRugs" SortExpression="numBathRugs" />
                        </Columns>
                        <EditRowStyle BackColor="#999999" />
                        <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                        <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                        <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                        <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                        <SortedAscendingCellStyle BackColor="#E9E7E2" />
                        <SortedAscendingHeaderStyle BackColor="#506C8C" />
                        <SortedDescendingCellStyle BackColor="#FFFDF8" />
                        <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                    </asp:GridView>
                </td>
            </tr>
            <tr>
                <td class="auto-style3">&nbsp;</td>
                <td class="auto-style3">
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:HotelManagementConnectionString %>" SelectCommand="SELECT [floor], [attendant], [roomNum], [timeStart], [timeEnd], [vacantYesOrNo], [numBedSheets], [numPillowCases], [numHandTowels], [numBathMats], [numBathRugs] FROM [HousekeepingDetails] WHERE ([dateOfHousekeeping] = @dateOfHousekeeping)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="lblDate" DbType="Date" Name="dateOfHousekeeping" PropertyName="Text" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </td>
            </tr>
            <tr>
                <td class="auto-style3">&nbsp;</td>
                <td class="auto-style3">&nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style3">&nbsp;</td>
                <td class="auto-style3">
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style3">&nbsp;</td>
                <td class="auto-style3">
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
            <tr>
                <td class="auto-style5"></td>
                <td class="auto-style3">
                    &nbsp;</td>
            </tr>
            <tr>
                <td>&nbsp;</td>
                <td>
                    &nbsp;</td>
            </tr>
        </table>
    
    </div>
    </form>
</body>
</html>